  Zakkis.PHP.Excel.Parser.Pro.v4.5

           http://www.zakkis.ca/products/abc_excelparser/index.php


   ,    MS  Excel 
     , HTML    ..?  
    PHP  Unix  Linux,   ,  
   Windows  COM? 
 PHP  Excel PARSER -    . ,     
 -    excel.php  PHP     
  .

   PHP Excel Parser,   ,
    Excel   !   
     01.01.1970!


      4.0 :
     MAC  Excel

      4.5 :
        4.0 (   )
      ( )
    


:
 Parser -       Excel  Excel 5.0  Excel 2000  XP.
        .      unicode
 (8-bits )   unicode (16-bits ) .

 :
      ,    
    PHP.     PHP  > = 4.3.x.



    

 include_once ("excel.php"); //  ,     .
 $excel = new ExcelFileParser ($logfilename, $logtype); $logfilename -   (    ).     -  ,    . 
 $logtype -  .     ABC_NO_LOG -  . 
       : 
 ABC_CRITICAL
 ABC_ERROR
 ABC_ALERT
 ABC_WARNING
 ABC_NOTICE
 ABC_INFO
 ABC_DEBUG
 ABC_TRACE
 ABC_VAR_DUMP
 ABC_NO_LOG 
      .       .


 
       Excel: 
 ParseFromFile ($filename)
     ,     
       .      .

 ParseFromString ($contents)
      ,     ,
      .  ,     
 (PHP        ,      !).
    !!!       .     !

 :
 $error_code = $excel->ParseFromFile($filename)
 $fd = fopen( $filename, 'rb');
 $content = fread ($fd, filesize ($name));
 fclose($fd);
 $error_code = $excel->ParseFromString($content);
 unset( $content, $fd );

  :
 0 -  
 1 -   
 2 -   ,    Excel
 3 -     Excel
 4 -   
 5 -   Excel   Excel   Excel 5.0
 6 -  
 7 - ,  
 8 -    

  :  7 ,   Excel    OLE2   ( MS WORD)

  

 int $excel->biff_version
 Excel  BIFF  (7 = Excel 5-7,  8  2000, 10 = XP)
 array $excel->worksheet
 ,    
 array $excel->format 
 ,       

 
 $worksheet_number =    Excel  -      ,  
   count($excel->worksheet['name']) 

 boolean $excel->worksheet['unicode'][$worksheet_number]
      unicode,    TRUE, 
 FALSE     unicode

 string $excel->worksheet['name'][$worksheet_number]
        unicode

 int $excel->worksheet['data'][$worksheet_number]['biff_version']
 BIFF  


 
 array $excel->worksheet['data'][$worksheet_number]['cell']
 ,       . 
 $row =   (   0)
 $col =   (   0)  Excel   'A', 'B', 'C',   

 int $excel->worksheet['data'][$worksheet_number]['max_row']
    (!     !). ,  
    1,3,8 -   8,   3
 

 int $excel->worksheet['data'][$worksheet_number]['max_col']
    (      , . ) 

 int $excel->worksheet['data'][$worksheet_number]['cell'][$row][$col]['type']  
 ,   : 
 0 - 
 1 -  
 2 -    
 3 - 

 mixed $excel->worksheet['data'][$worksheet_number]['cell'][$row][$col]['data']
    - 0,       (  ) 
    - 1,    
    - 2,      
    - 3,      Excel

 int $excel->worksheet['data'][$worksheet_number]['cell'][$row][$col]['font']
 -   ,   

  
 ,     ,    $excel- >fonts  . 
    :

 $font = $excel->fonts[$index]; 

 $font['size'] -      
 $font['italic'] -    true/false 
 $font['strikeout'] -  t true/false 
 $font['bold']-   true/false  

 $font['script'] -     :
 XF_SCRIPT_NONE -  . 
 XF_SCRIPT_SUPERSCRIPT -   . 
 XF_SCRIPT_SUBSCRIPT -   .

 $font['underline'] -      : 
 XF_UNDERLINE_NONE -  . 
 XF_UNDERLINE_SINGLE -   .
 XF_UNDERLINE_DOUBLE -   .
 XF_UNDERLINE_SINGLE_ACCOUNTING -   
 XF_UNDERLINE_DOUBLE_ACCOUNTING -   

 $font['name'] -  . 

 

    (-SST): 
         ,    
 .     ,        .

   :
 if( $excel->worksheet['data'][$worksheet_number]['cell'][$row][$col]['type'] == 0 )
 {
  $ind = $excel->worksheet['data'][$worksheet_number]['cell'][$row][$col]['data'];
 }
 array $excel->sst 
   
 boolean $excel->sst['unicode'][$ind]
  , ,      (TRUE)   (FALSE) unicode

 string $excel->sst['data'][$ind] 
   

  
     Excel - ( ,   1900  )      timestamp

  $excel->xls2tstamp($xlsdate)
      ,   unix timestamp  
      PHP.    Windows  timestamp  ( )
 - 1,1,1970         .

       ,   :
 $ret = $excel->getDateArray($xlsdate);

 : 
 $ret['day']   =  .
 $ret['month'] = .
 $ret['year']  = .



  
     logfile -       : ExcelFileParser('logfile.txt',LOG_LEVEL);
 LOG_LEVEL    :
 ABC_CRITICAL 
 ABC_ERROR 
 ABC_ALERT 
 ABC_WARNING 
 ABC_NOTICE 
 ABC_INFO 
 ABC_DEBUG 
 ABC_TRACE 
 ABC_VAR_DUMP 
 
   ,             . 
  ABC_NO_LOG -   .

  
 . sample  -    .